SongAlbumRecording
Let's Do It Let's Dance with the Tony Pastor Orchestra 2042
   "Can-Can 3226
   "Billie Holiday on the Net 3790
   "All-Time Greatest Hits of Benny Goodman 6467
   "Jazz in the Charts (1928-1929) 6836
   "Ella Sings the Cole Porter Songbook 6980
   "   "7006
   "Quintessential Billie Holiday, The (1940-1942) 7028
   "Mellow Guitar 10086

SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Let's Do It"